Api

This RESTful API works with the data contained in the sample database, which is used in the SQLite tutorial found at SQLite Sample Database, the database shows a control system for the sale of musical tracks (songs), among the main tables we can find are: Clients, Invoices and Tracks (songs).

RESTful APIs enable you to call individual API endpoints to perform the following actions:

This Api does not provide a full fledged, production level RESTful service, it is intended for developers that want to practice getting data from a web service formatted as a Json object. The data coming from this service can not be modified, you can not insert new items and deletion is not available, but the response coming from calling any of these methods mimics a proper response giving the method used.

This API is a modern JSON API that surfaces all of the info you’ll need to build any experience you need:

Call: Get track by id:

https://api.hernandez-julio.com/webapi/v1/tracks/{1}

Response:

{
  "TrackId":1,
  "Name":"For Those About To Rock (We Salute You)",
  "AlbumId":1,
  "MediaTypeId":1,
  "GenreId":1,
  "Composer":"Angus Young, Malcolm Young, Brian Johnson",
  "Milliseconds":343719,
  "Bytes":11170334,
  "UnitPrice":0.989999999999999992
}

Call: Search a track by name:

https://api.hernandez-julio.com/webapi/v1/tracks/search?searchTerm={name}

Response:

                  
{
  "links":[ 
    {"prev_page":"https://api.hernandez-julio.com/webapi/v1/tracks/search?searchTerm=name&page=e2lkPTF9"},
    {"next_page":"https://api.hernandez-julio.com/webapi/v1/tracks/search?searchTerm=name&page=e2lkPTIxfQ=="},
  ],
  "data":[
    {
      "TrackId": 1145,
      "Name": "Whatsername",
      "AlbumId": 89,
      "MediaTypeId": 1,
      "GenreId": 4,
      "Composer": "Green Day",
      "Milliseconds": 252316,
      "Bytes": 8244843,
      "UnitPrice": 0.99
    },
    {
      "TrackId": 1211,
      "Name": "Hallowed Be Thy Name (Live) [Non Album Bonus Track]",
      "AlbumId": 94,
      "MediaTypeId": 2,
      "GenreId": 1,
      "Composer": "",
      "Milliseconds": 431262,
      "Bytes": 7205816,
      "UnitPrice": 0.99
    },
    {
      "TrackId": 1223,
      "Name": "Hallowed Be Thy Name",
      "AlbumId": 95,
      "MediaTypeId": 1,
      "GenreId": 3,

...

Call: List paginated tracks:

https://api.hernandez-julio.com/webapi/v1/tracks

Response:

{
  "Links":[ 
      {"prev_page":"https://api.hernandez-julio.com/webapi/v1/tracks?page=e2lkPTF9"},
      {"next_page":"https://api.hernandez-julio.com/webapi/v1/tracks?page=e2lkPTIxfQ=="},
    ],    
  "data":[        
       {
          "TrackId":1,
          "Name":"For Those About To Rock (We Salute You)",
          "Album":"For Those About To Rock We Salute You",
          "MediaType":"MPEG audio file",
          "Genre":"Rock",
          "Composer":"Angus Young, Malcolm Young, Brian Johnson",
          "Milliseconds":343719,
          "Bytes":11170334,
          "UnitPrice":0.99
       },
       {
          "TrackId":2,
          "Name":"Balls to the Wall",
          "Album":"Balls to the Wall",
          "MediaType":"Protected AAC audio file",
          "Genre":"Rock",
          "Composer":null,

...

Once your identity is confirmed, you can log in to create an access key; use this key to access this service.

When you sign up you will find your API token on your dashboard. Simply add this API token as the value in the authorization header of your request to gain access. Examples of how this is done can be found in the documentation.